MyDAC

TMyTableOptions Members

TMyTableOptions class overview.

Properties

Name Description

AutoPrepare (inherited from TMyDataSetOptions)

 Used to execute automatic TCustomDADataSet.Prepare on a query execution.

AutoRefresh (inherited from TMyDataSetOptions)

 Used to automatically refresh dataset every AutoRefreshInterval seconds.

AutoRefreshInterval (inherited from TMyDataSetOptions)

 Used to define in what time interval in seconds the Refresh or TCustomMyDataSet.RefreshQuick method of a DataSet is called.

BinaryAsString (inherited from TMyDataSetOptions)

 Used to specify a method of representation of the BINARY and VARBINARY fields.

CacheCalcFields (inherited from TDADataSetOptions)

 Used to enable caching of the TField.Calculated and TField.Lookup fields.

CheckRowVersion (inherited from TMyDataSetOptions)

 Used to determine whether a dataset checks for rows modifications made by another user on automatic generation of SQL statement for update or delete data.

CompressBlobMode (inherited from TDADataSetOptions)

 Used to store values of the BLOB fields in compressed form.

CreateConnection (inherited from TMyDataSetOptions)

 Used to specify if an additional connection to a server should be established to execute an additional query in the TCustomMyDataSet.FetchAll=False mode.

DefaultValues (inherited from TMyDataSetOptions)

 Used to fill the DefaultExpression property of TField objects with appropriate value.

DetailDelay (inherited from TDADataSetOptions)

 Used to get or set a delay in milliseconds before refreshing detail dataset while navigating master dataset.

EnableBoolean (inherited from TMyDataSetOptions)

 Used to specify the method of representation of the TINYINT(1) fields.

FieldsAsString (inherited from TMyDataSetOptions)

 Used to store all non-BLOB fields as string (native MySQL format).

FlatBuffers (inherited from TDADataSetOptions)

 Used to control how a dataset treats data of the ftString and ftVarBytes fields.

FullRefresh (inherited from TMyDataSetOptions)

 Used to specify the fields to include in automatically generated SQL statement when calling the TCustomDADataSet.RefreshRecord method. Default value is false.

HandlerIndex

 Used to assign an index and a value that this index should satisfy.

InsertAllSetFields (inherited from TDADataSetOptions)

 Used to include all set dataset fields in the generated INSERT statement

LocalMasterDetail (inherited from TDADataSetOptions)

 Used for TCustomDADataSet to use local filtering to establish master/detail relationship for detail dataset and does not refer to the server.

LongStrings (inherited from TDADataSetOptions)

 Used to represent string fields with the length that is greater than 255 as TStringField.

MasterFieldsNullable (inherited from TDADataSetOptions)

 Allows to use NULL values in the fields by which the relation is built, when generating the query for the Detail tables (when this option is enabled, the performance can get worse).

NullForZeroDate (inherited from TMyDataSetOptions)

 Used for MySQL server to represent the value for for datetime fields with invalid values as Null or '0001-01-01' ('0100-01-01' for CLR).

NumberRange (inherited from TMyDataSetOptions)

 Used to set the MaxValue and MinValue properties of TIntegerField and TFloatField to appropriate values.

QueryRecCount (inherited from TMyDataSetOptions)

 Used for TCustomDADataSet to perform additional query to get record count for this SELECT so the RecordCount property reflects the actual number of records.

QuoteNames (inherited from TMyDataSetOptions)

 Used for TCustomMyDataSet to quote all field names in autogenerated SQL statements.

RemoveOnRefresh (inherited from TMyDataSetOptions)

 Used for dataset to remove a record locally if the RefreshRecord procedure can't find necessary record on the server.

RequiredFields (inherited from TMyDataSetOptions)

 Used for TCustomDADataSet to set the Required property of TField objects for NOT NULL fields.

ReturnParams (inherited from TMyDataSetOptions)

 Used to return the new value of the fields to dataset after insert or update.

SaveBlobsAsHex (inherited from TMyDataSetOptions)

 Used to save BLOB data in hexadecimal format in a database after calling the TMyQuery.SaveToXML method.

SetEmptyStrToNull (inherited from TMyDataSetOptions)

 Force replace of empty strings with NULL values in data. The default value is False.

SetFieldsReadOnly (inherited from TMyDataSetOptions)

 Used to specify whether fields not belonging to the current updating table get read-only attribute.

StrictUpdate (inherited from TMyDataSetOptions)

 Used for TCustomDADataSet to raise an exception when the number of updated or deleted records does not equal 1.

TrimFixedChar (inherited from TMyDataSetOptions)

 Used to specify whether to discard all trailing spaces in string fields of the dataset.

TrimVarChar (inherited from TMyDataSetOptions)

 Used to specify whether to discard all trailing spaces in the variable-length string fields of a dataset.

UpdateAllFields (inherited from TDADataSetOptions)

 Used to include all dataset fields in the generated UPDATE and INSERT statements.

UpdateBatchSize (inherited from TDADataSetOptions)

 Used to get or set a value that enables or disables batch processing support, and specifies the number of commands that can be executed in a batch.

UseHandler

 Used for the HANDLER statement to be used instead of the SELECT statement.
© 1997-2025 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback